In [1]:
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
from PlateAnalysis_Echo import PlateDataset
from tqdm import tqdm

dataset = PlateDataset('20191104_Dopt.CSV','D_Opt.csv')


output =  pd.DataFrame([],columns = [ 'K','percentDMSO', 'Vol','km', 'vmax', 'loss', 'r_squared'])
for i in tqdm(range(1,19)):
    output=output.append(dataset.CalculateMetrics(i))
    
output = output.reset_index(drop=True)
output.to_csv('DOptExperimnentResults.csv')
output
100%|██████████| 18/18 [00:13<00:00,  1.33it/s]
Out[1]:
K percentDMSO Vol km vmax loss r_squared
0 1.000000 5.000000 20.0 2.477096 0.043018 0.007542 0.358127
1 2.636364 3.181818 20.0 2.562310 0.038098 0.010789 0.570633
2 4.000000 1.000000 20.0 1.262799 0.060722 0.001688 0.989200
3 4.000000 1.000000 20.0 2.656589 0.056360 0.005327 0.906591
4 1.545455 1.000000 20.0 2.345846 0.028151 0.012497 0.385633
5 1.000000 5.000000 20.0 2.057473 0.014975 0.012475 0.071120
6 2.636364 3.181818 20.0 0.209351 0.057884 0.027953 -0.043036
7 2.636364 5.000000 29.0 3.000489 0.054683 0.005098 0.804826
8 2.636364 5.000000 29.0 3.316767 0.076424 0.018771 0.468825
9 1.000000 2.818182 29.0 2.266800 0.035202 0.024059 0.154214
10 1.000000 2.818182 29.0 3.246844 0.086234 0.005716 0.942767
11 1.000000 5.000000 40.0 3.214294 0.076385 0.014323 0.369197
12 1.000000 1.000000 40.0 2.029973 0.016484 0.046828 -0.378452
13 4.000000 5.000000 40.0 1.482239 0.014382 0.026557 -0.145138
14 1.000000 5.000000 40.0 3.143757 0.073450 0.029190 0.141555
15 1.000000 1.000000 40.0 2.183681 0.024263 0.025474 -0.017859
16 4.000000 1.000000 40.0 0.039473 0.105401 0.004752 0.965356
17 4.000000 1.000000 40.0 0.901144 0.109199 0.004858 0.979317
In [2]:
for i in range(1,19):
    dataset.PlotFigure(i)
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image